Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Changes itself after I have inputted.
Can anyone help this luddite?
I am constructing a table in Excel and have a column showing monetary amounts. However on one box, when I put the figure in then move on, the data changes to a date (13/02/1900). Any help much appreciated (need to get this to the accountant before HMRC jump on me, lol). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Changes itself after I have inputted.
Hi Funky
The cell will have been formatted as a date. Select the offending cells and press Ctrl + Shift + # to get General number formatting or Ctrl + Shift + $ to get Currency formatting Judith -- Hope this helps "Funky" wrote: Can anyone help this luddite? I am constructing a table in Excel and have a column showing monetary amounts. However on one box, when I put the figure in then move on, the data changes to a date (13/02/1900). Any help much appreciated (need to get this to the accountant before HMRC jump on me, lol). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Changes itself after I have inputted.
you need to change the format of cell. on the toolbar menu, click Format --
Cells, and then choose from the list (other than date). hope this helps. "Funky" wrote: Can anyone help this luddite? I am constructing a table in Excel and have a column showing monetary amounts. However on one box, when I put the figure in then move on, the data changes to a date (13/02/1900). Any help much appreciated (need to get this to the accountant before HMRC jump on me, lol). |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Changes itself after I have inputted.
On Thu, 27 Sep 2007 05:07:02 -0700, Funky
wrote: Can anyone help this luddite? I am constructing a table in Excel and have a column showing monetary amounts. However on one box, when I put the figure in then move on, the data changes to a date (13/02/1900). Any help much appreciated (need to get this to the accountant before HMRC jump on me, lol). I assume you are inputting the value as a decimal number, and not using your system date delimiter. If that is the case, then: Select the errant cell. Edit/Clear/Formats If you are using a date delimiter in your value, then you may need to precede the entry with an "=", but post back exactly what you are inputting and exactly what you see. --ron |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Changes itself after I have inputted.
Excel is "helpful" and tries to anticipate how you'd like the data to
display based on keystrokes you enter. When you got the displayed result 13/02/1900 Excel thought you were entering a date, or perhaps that cell was formatted as a date. That displayed output may also be the result of a conflict between your computer's regional settings and the type of data you entered. What figure did you enter, and how is the cell formatted? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Changes itself after I have inputted.
Just change the formatting of the cell. Right click on the cell and
select Format Cells. Make any adjustments that you need to to get the desired outcome. Funky wrote: Can anyone help this luddite? I am constructing a table in Excel and have a column showing monetary amounts. However on one box, when I put the figure in then move on, the data changes to a date (13/02/1900). Any help much appreciated (need to get this to the accountant before HMRC jump on me, lol). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Last Value that inputted | Excel Discussion (Misc queries) | |||
Record date cell is inputted | Excel Discussion (Misc queries) | |||
Calculating from last inputted cell | New Users to Excel | |||
adding months to an inputted date | Excel Discussion (Misc queries) | |||
calculating from last inputted cell | Excel Discussion (Misc queries) |