| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why do I get #### signs when entering cash amount in account mode
I have my cell formated in accounting and when i enter my cash amount it
gives me ##### signs. I have changed the format to anything other than accounting and it puts in my amount. I want my workbook in accounting mode because it is easier to read for me. What on earth have I dont wrong to the thing? Please help.. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why do I get #### signs when entering cash amount in account mode
Just make the column a little wider.
Accounting format has spaces added by default to account for the possible insertion of parenthesis, where the positive and negative numbers will align with each other. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "banae9" wrote in message ... I have my cell formated in accounting and when i enter my cash amount it gives me ##### signs. I have changed the format to anything other than accounting and it puts in my amount. I want my workbook in accounting mode because it is easier to read for me. What on earth have I dont wrong to the thing? Please help.. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why do I get #### signs when entering cash amount in account mode
Try to widen the column
-- Regards, Peo Sjoblom "banae9" wrote in message ... I have my cell formated in accounting and when i enter my cash amount it gives me ##### signs. I have changed the format to anything other than accounting and it puts in my amount. I want my workbook in accounting mode because it is easier to read for me. What on earth have I dont wrong to the thing? Please help.. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why do I get #### signs when entering cash amount in account mode
Or use a smaller font.
banae9 wrote: I have my cell formated in accounting and when i enter my cash amount it gives me ##### signs. I have changed the format to anything other than accounting and it puts in my amount. I want my workbook in accounting mode because it is easier to read for me. What on earth have I dont wrong to the thing? Please help.. -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why do I get #### signs when entering cash amount in account m
Gee... Can't you tell I am such a pro at Excel. It worked... And to think of
all the cussing I was doing for the whole HOUR I spent trying to figure it out. I may need to re-take my Excel class. haha Thanks so much! Banae9 "RagDyer" wrote: Just make the column a little wider. Accounting format has spaces added by default to account for the possible insertion of parenthesis, where the positive and negative numbers will align with each other. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "banae9" wrote in message ... I have my cell formated in accounting and when i enter my cash amount it gives me ##### signs. I have changed the format to anything other than accounting and it puts in my amount. I want my workbook in accounting mode because it is easier to read for me. What on earth have I dont wrong to the thing? Please help.. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why do I get #### signs when entering cash amount in account m
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "banae9" wrote in message ... Gee... Can't you tell I am such a pro at Excel. It worked... And to think of all the cussing I was doing for the whole HOUR I spent trying to figure it out. I may need to re-take my Excel class. haha Thanks so much! Banae9 "RagDyer" wrote: Just make the column a little wider. Accounting format has spaces added by default to account for the possible insertion of parenthesis, where the positive and negative numbers will align with each other. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "banae9" wrote in message ... I have my cell formated in accounting and when i enter my cash amount it gives me ##### signs. I have changed the format to anything other than accounting and it puts in my amount. I want my workbook in accounting mode because it is easier to read for me. What on earth have I dont wrong to the thing? Please help.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate account codes that total amount | Excel Discussion (Misc queries) | |||
| Subtotal by Account (cash, liability, revenue, expense) in Excel? | Excel Worksheet Functions | |||
| Formula for Petty Cash form to return -/+ amount? | Excel Worksheet Functions | |||
| Financial Calc: present cash value of a future amount | Excel Worksheet Functions | |||
| automatic entering Balance at every entry in my bank account | Excel Discussion (Misc queries) | |||
Linear Mode
