Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello
To creacte a webpage with lot a data i want to export this data from excel to xml. So far so good While exporting the data the date format changes in the excel number and not the dd-mm-yyyy format. Numiek value for example 10,05 is change in 10,0494449 (the original value) but i only want two digi 10,05. Can anybody help me thanks in advance |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You may need to produce a helper column, either using the ROUND() function,
or the TEXT() function. -- David Biddulph "joost" wrote in message ... Hello To creacte a webpage with lot a data i want to export this data from excel to xml. So far so good While exporting the data the date format changes in the excel number and not the dd-mm-yyyy format. Numiek value for example 10,05 is change in 10,0494449 (the original value) but i only want two digi 10,05. Can anybody help me thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |