#1   Report Post  
Old February 3rd 12, 10:36 AM
Junior Member
 
First recorded activity by ExcelBanter: Feb 2012
Location: England
Posts: 1
Default Formatting

Hey, Iím using Excel 2010, and have made a spread sheet to automatically fill out forms, but I have one problem, I have a cell which requires the document reference, but the reference can be anything so for example:

Dec 11
01/12/2011
01 Dec 11
101
SR0589461
No 78

The trouble now is as usual Excel is trying to second guess me once I input a date it always automatically formats to that date. Is there a way to turn the formatting off in this particular cell or work book, also I could use a formula, I tried something like this: =IF(H1135000,IF(DAY(H11)=1,TEXT(H11,"mmm-yy"),TEXT(H11,"dd-Mm-yyyy")),TEXT(H11,0)) but I could not account for all the variables.

If someone can help that would be great.

Thanks

Boomey

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting--different formatting depending on cell con Tammy S. Excel Discussion (Misc queries) 3 March 30th 09 08:11 PM
Formatting cells in a column with conditional formatting? shamor Excel Discussion (Misc queries) 8 May 19th 08 10:11 PM
Protect Cell Formatting including Conditional Formatting Mick Jennings Excel Discussion (Misc queries) 5 November 13th 07 06:32 PM
expanding custom formatting without removing existing cell formatting? Keith Excel Worksheet Functions 3 December 27th 06 02:54 PM
Decimal Formatting in Windows English vs European Formatting Drummer361 Excel Programming 3 August 7th 06 02:48 PM


All times are GMT +1. The time now is 01:08 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017