Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Currency question
Would like to be able to enter a number w/o need to enter decimal point but
have it show with DP. IOW- If I enter 123456 in a cell, would like it to show as 1,234.56 Suggestions please, L. |
#2
|
|||
|
|||
L/P, format the cell as number with 2 decimal places and use 1000 seperator
then go to tool,s options, edit, and check fixed decimal places -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "L/P" wrote in message ... Would like to be able to enter a number w/o need to enter decimal point but have it show with DP. IOW- If I enter 123456 in a cell, would like it to show as 1,234.56 Suggestions please, L. |
#3
|
|||
|
|||
Thanks for the info. worked...
Question- Does the "fixed decimal places" work for all cells or ONLY cells formatted as a numbers, currency, etc.etc.? Besides columns for check amounts, I have columns for date and check numbers, ex. 1/08 and check # 1258 and don't what it showing as 1.08 and/or 12.58 "Paul B" wrote in message ... L/P, format the cell as number with 2 decimal places and use 1000 seperator then go to tool,s options, edit, and check fixed decimal places -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "L/P" wrote in message ... Would like to be able to enter a number w/o need to enter decimal point but have it show with DP. IOW- If I enter 123456 in a cell, would like it to show as 1,234.56 Suggestions please, L. |
#4
|
|||
|
|||
FD works only on numerics, not dates or text.
"check # 1258" is text. Gord Dibben Excel MVP On Thu, 28 Apr 2005 09:52:42 -0500, "L/P" wrote: Thanks for the info. worked... Question- Does the "fixed decimal places" work for all cells or ONLY cells formatted as a numbers, currency, etc.etc.? Besides columns for check amounts, I have columns for date and check numbers, ex. 1/08 and check # 1258 and don't what it showing as 1.08 and/or 12.58 "Paul B" wrote in message ... L/P, format the cell as number with 2 decimal places and use 1000 seperator then go to tool,s options, edit, and check fixed decimal places -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "L/P" wrote in message ... Would like to be able to enter a number w/o need to enter decimal point but have it show with DP. IOW- If I enter 123456 in a cell, would like it to show as 1,234.56 Suggestions please, L. |
#5
|
|||
|
|||
L/P, I don't use fixed decimal but it looks like it will change most
formats, you could format the column with the check number as text and it will not change as long as you don't want to do any calculations on them, looks like dates should be OK. Beaware that if you cut on fixed decimal it will work that way for all workbooks. You could use a macro to cut it on and off for that workbook and/or to check what column you are in and turn fixed decimals on and off but this seams like a lot just to keep from typing in a decimal. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "L/P" wrote in message ... Thanks for the info. worked... Question- Does the "fixed decimal places" work for all cells or ONLY cells formatted as a numbers, currency, etc.etc.? Besides columns for check amounts, I have columns for date and check numbers, ex. 1/08 and check # 1258 and don't what it showing as 1.08 and/or 12.58 "Paul B" wrote in message ... L/P, format the cell as number with 2 decimal places and use 1000 seperator then go to tool,s options, edit, and check fixed decimal places -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "L/P" wrote in message ... Would like to be able to enter a number w/o need to enter decimal point but have it show with DP. IOW- If I enter 123456 in a cell, would like it to show as 1,234.56 Suggestions please, L. |
#6
|
|||
|
|||
Thanks to all.
It appears that if I format the check # column as "text" and the date column as "date" then the other columns, i.e. check amount, utlities, payroll, office suppies, etc.etc.etc. it will work ok. Again, thanks for the help. L. "Paul B" wrote in message ... L/P, I don't use fixed decimal but it looks like it will change most formats, you could format the column with the check number as text and it will not change as long as you don't want to do any calculations on them, looks like dates should be OK. Beaware that if you cut on fixed decimal it will work that way for all workbooks. You could use a macro to cut it on and off for that workbook and/or to check what column you are in and turn fixed decimals on and off but this seams like a lot just to keep from typing in a decimal. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "L/P" wrote in message ... Thanks for the info. worked... Question- Does the "fixed decimal places" work for all cells or ONLY cells formatted as a numbers, currency, etc.etc.? Besides columns for check amounts, I have columns for date and check numbers, ex. 1/08 and check # 1258 and don't what it showing as 1.08 and/or 12.58 "Paul B" wrote in message ... L/P, format the cell as number with 2 decimal places and use 1000 seperator then go to tool,s options, edit, and check fixed decimal places -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "L/P" wrote in message ... Would like to be able to enter a number w/o need to enter decimal point but have it show with DP. IOW- If I enter 123456 in a cell, would like it to show as 1,234.56 Suggestions please, L. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency Style button | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Changing Dollar sign to another currency not listed in Excel | Excel Discussion (Misc queries) | |||
Default Currency | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |